Entity DefinitionLogical Name : EquipmentClass |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| EquipmentClassID (PK) | A unique identifier for the class of equipment. | ID_EQ_CLS | Identity | integer | |
| SupplierID (FK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | Supplier(PA_SPR) |
| ServiceProviderID (FK) | A unique system assigned identifier for the Service Provider. | ID_PVR_SV | Identity | integer | ServiceProvider(PA_PVR_SV) |
| ManufacturerName | The name of the hardware manufacturer | NM_MF | Name | varchar(40) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| Supplier | supplies | EquipmentClass |
| ServiceProvider | services | EquipmentClass |
| EquipmentClass | classifies | Equipment |